package vip.xiaonuo.smzq.modular.user.mapper;

import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.user.entity.Kyqrqyb;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 矿业权人企业表 Mapper
 *
 * @author sqq
 * @since 2024-07-20
 */
@Mapper
public interface KyqrqybMapper extends BaseMapper<Kyqrqyb> {
    @Select("SELECT CONCAT(kyqr, ',', shxydm) AS kyqmc FROM kcl_ks  where (shxydm IS NOT NULL AND shxydm <> '')  GROUP BY kyqr, shxydm")
    List<String> getKyqrqyb();
}
